<?php

/**
 *      $Id: install.php longdu_gz
 */

if(!defined('IN_DISCUZ')) {
	exit('Access Denied');
}

$threadpic = DB::table('forum_threadpic');
$sql = <<<EOF
CREATE TABLE IF NOT EXISTS `$threadpic` (
	`aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
	`tid` mediumint(8) unsigned NOT NULL DEFAULT '0',
	`fid` int(10) unsigned NOT NULL DEFAULT '0',
	`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
	`filename` varchar(255) NOT NULL DEFAULT '',
	`filesize` int(10) unsigned NOT NULL DEFAULT '0',
	`attachment` varchar(255) NOT NULL DEFAULT '',
	`remote` tinyint(1) unsigned NOT NULL DEFAULT '0',
	`width` smallint(6) unsigned NOT NULL DEFAULT '0',
	`thumb` tinyint(1) unsigned NOT NULL DEFAULT '0',
	`dateline` int(10) unsigned NOT NULL DEFAULT '0',
	`ox` int(10) unsigned NOT NULL DEFAULT '0',
	`attdesc` varchar(255) NOT NULL DEFAULT '',
	PRIMARY KEY (`aid`),
	KEY `tid` (`tid`),
	KEY `uid` (`uid`)
) ENGINE=MyISAM;
EOF;

runquery($sql);

$finish = TRUE;

?>